{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["TL431 Inputs"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"TL431 Inputs","index":0,"n_rows":28,"n_cols":16,"rows_kept":28,"cut":false,"hidden":false,"merged":[[26,12,27,12],[20,0,21,0],[0,0,0,3],[0,4,0,8]]}
["TL431 Shunt Regulator Design",null,null,null,"Macro: No code has been alterred. Ingen koder er ændret.",null,null,null,null,null,null,"I have contact P.D. Rodgers for permission to use this Excel spreadsheet."]
[null,"Select a device",null,null,"Can only be used with active macro. Kan kun bruges med aktiv makro.",null,null,null,null,null,null,"But the e-mail was returned with the message that this could not be delivered."]
[null,"Vælg en komponent",null,null,null,null,null,null,null,null,null,"Jeg har kontakte P.D. Rodgers for tilladelse til at benytte dette Excel regneark."]
[null,null,null,null,null,null,null,null,null,null,null,"Men e-mailen kom retur med besked om, at denne ikke kunne afleveres."]
[null,null,null,null,null,null,null,null,null,null,null,"Den originale version findes her:",null,null,"http://www.ti.com/tool/tl431calc "]
[null,null,null,null,null,null,null,null,null,null,null,"Data blad for TL43xx Familien:",null,null,"http://www.ti.com/lit/ds/symlink/tl431.pdf "]
[]
[null,"Enter your parameters",null,null,null,null,null,null,null,null,null,"Vo = Vref*(1+R2/R3)+Iref*R2 =",null,null,{"$f":"+ROUND(O9*(1+B19/B20)+(O10/10^6*B19),2)","v":3.1}," V"]
[null,"Tast dine data",null,null,null,null,null,null,null,null,null,"Vref =",null,null,2.4900000000000002," V"]
["Vin (Min) ",3.6," V","Yellow cells Input",null,null,null,null,null,null,null,"IRef =IR2/Ratio",null,null,{"$f":"+(G19/B14)*1000","v":4}," µA"]
["Vin (Max) ",3.6," V","Gule celler Input",null,null,null,null,null,null,null,"RLoad =",null,null,2200," Ω"]
["Vo ",3.1," V",null,null,null,"TL431    36V, 100mA  2%",null,null,null,null,"IRload=",null,null,{"$f":"+ROUND(O8*10^3/O11,2)","v":1.41}," mA"]
["Io ",1.4," mA",null,null,null,"TL431A  36V, 100mA, 1%"]
["IDiv/IRef",500," >= 100",null,null,null,"TL1431  36V, 100mA, 0.4%"]
[null,null,null,"Blue cells Output",null,null,"TLV431  6V, 15mA, 1%"]
[null,null,null,"Blå celler Output",null,null,null,null,null,null,null,null,{"$f":"+CONCATENATE(B18,C18)","v":"100 Ω"},null,null,{"$f":"+CONCATENATE(O8,P8)","v":"3,1 V"}]
[]
["R1 ",100," Ω",2.4728000000000011E-3," PR1 (W) Max",null,4.4000000000000004," IR1 (mA) Max"]
["R2 ",301," Ω",1.2000000000000003E-3," PR2 (W)",null,2," IR2 (mA)",null,null,{"$f":"+A10","v":"Vin (Min) "},{"$f":"CONCATENATE(B10,C10)","v":"3,6 V"},null,"Io"]
["R3 ",1240," Ω",5.0000000000000001E-3," PR3 (W)",null,2," IR3 (mA)",null,null,null,null,{"$f":"+CONCATENATE(B19,C19)","v":"301 Ω"},{"$f":"CONCATENATE(B13,C13)","v":"1,4 mA"}]
["C1 ",27000," pF",1.1772800000000002E-2," PTotal (W)",null,null,null,null,null,{"$f":"+A11","v":"Vin (Max) "},{"$f":"CONCATENATE(B11,C11)","v":"3,6 V"}]
[null,1.5," uF",null,null,null,null,null,null,null,null,null,{"$f":"+CONCATENATE(O9,P9)","v":"2,49 V"},{"$f":"CONCATENATE(O10,P10)","v":"4 µA"}]
[null,null,"Vo min ",3.0447177419354841," V",-1.7832986472424466," %",null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(O12,P12)","v":"1,41 mA"}]
[null,null,"Vo max ",3.1689919354838709," V",2.2255463059313172," %",null,null,null,null,null,{"$f":"+CONCATENATE(B20,C20)","v":"1240 Ω"}]
[null,null,"Efficiency ",53.260206987326818," % (at Vo(MIN))"]
[]
[null,"Note:  C1 should be less than the value in B21 or greater than the value in B22 to insure stability.",null,null,null,null,null,null,null,null,null,null,"C1","<",{"$f":"CONCATENATE(B21/1000,C22)","v":"27 uF"}]
[null,"NB:    C1 skal være mindre end værdien i B21 eller større end værdien i B22 for at sikre stabilitet",null,null,null,null,null,null,null,null,null,null,null,">",{"$f":"CONCATENATE(B22,C22)","v":"1,5 uF"}]